دانلود کتاب اوراکل-دانلود کتاب oracle-Oracle Built-in Packages

A. What's on the Companion Disk?..................................................................................................................2
A.1 Installing the Guide...........................................................................................................................2
...............................................................................................................................................................................3
A.2 Using the Guide................................................................................................................................3
...............................................................................................................................................................................4
1. Introduction.....................................................................................................................................................5
1.1 The Power of Built−in Packages.......................................................................................................5
1.1.1 A Kinder , More Sharing Oracle........................................................................................6
...............................................................................................................................................................................7
1.2 Built−in Packages Covered in This Book..........................................................................................7
1.2.1 Application Development Packages................................................................................10
1.2.2 Server Management Packages.........................................................................................11
1.2.3 Distributed Database Packages........................................................................................12
.............................................................................................................................................................................14
1.3 Using Built−in Packages..................................................................................................................14
1.3.1 What Is a Package?..........................................................................................................14
1.3.2 Controlling Access with Packages...................................................................................15
1.3.3 Referencing Built−in Package Elements.........................................................................17
1.3.4 Exception Handling and Built−in Packages....................................................................18
1.3.5 Encapsulating Access to the Built−in Packages..............................................................24
1.3.6 Calling Built−in Packaged Code from Oracle Developer/2000 Release 1......................27
1.3.7 Accessing Built−in Packaged Technology from Within SQL.........................................30
.............................................................................................................................................................................38
1.4 Examining Built−in Package Source Code......................................................................................38
1.4.1 The STANDARD Package..............................................................................................39
1.4.2 The DBMS_STANDARD Package.................................................................................40
.............................................................................................................................................................................42
2. Executing Dynamic SQL and PL/SQL.......................................................................................................43
2.1 Examples of Dynamic SQL.............................................................................................................43
.............................................................................................................................................................................46
2.2 Getting Started with DBMS_SQL...................................................................................................46
2.2.1 Creating the DBMS_SQL Package..................................................................................46
2.2.2 Security and Privilege Issues...........................................................................................46
2.2.3 DBMS_SQL Programs....................................................................................................46
2.2.4 Types of Dynamic SQL...................................................................................................47
2.2.5 DBMS_SQL Exceptions..................................................................................................49
2.2.6 DBMS_SQL Nonprogram Elements...............................................................................49
.............................................................................................................................................................................52
2.3 The DBMS_SQL Interface..............................................................................................................52
2.3.1 Processing Flow of Dynamic SQL..................................................................................52
2.3.2 Opening the Cursor..........................................................................................................54
2.3.3 Parsing the SQL Statement..............................................................................................55
2.3.4 Binding Values into Dynamic SQL.................................................................................58
2.3.5 Defining Cursor Columns................................................................................................63
2.3.6 Executing the Cursor.......................................................................................................66
2.3.7 Fetching Rows.................................................................................................................66
2.3.8 Retrieving Values............................................................................................................69
2.3.9 Closing the Cursor...........................................................................................................76
2.3.10 Checking Cursor Status.................................................................................................77
2.3.11 Describing Cursor Columns...........................................................................................80